package com.gtq.uhome.mapper;

import com.gtq.uhome.vo.LogisticsVo;

import java.util.List;

/**
 * 站点后台，派送列表
 */
public interface LogisticsMapper {

    //选择消耗物料，查询物料名称，supplies表
    List<LogisticsVo> findSupName();
    //查询商品一二三级分类
    List<LogisticsVo> findCategoryName();

    //在user表中，通过手机号码获取userId
    List<LogisticsVo> findUserIdInUser(LogisticsVo logisticsVo);
    //在consignee表中通过consigneePhoneNumber查询consigneeId
    List<LogisticsVo> findConsigneeIdInConsignee(LogisticsVo logisticsVo);

    //对order_sup_relation表添加
    Integer insertIntoOrderSupRelation(LogisticsVo logisticsVo);
    //对order_detail表添加
    Integer insertOrderDetail(LogisticsVo logisticsVo);
    //对consignee_order_relation表添加
    Integer insertConsigneeOrderRelation(LogisticsVo logisticsVo);
    //对consignee表添加
    Integer insertConsignee(LogisticsVo logisticsVo);
    //对user表添加
    Integer insertUser(LogisticsVo logisticsVo);
    //对user_order_relation表添加
    Integer insertUserOrderRelation(LogisticsVo logisticsVo);
    //对user_site表添加
    Integer insertUserSite(LogisticsVo logisticsVo);
    //对order添加
    Integer insertOrder(LogisticsVo logisticsVo);
    //对order_site_relation表添加
    Integer insertOrderSiteRelation(LogisticsVo logisticsVo);
    //对delivery表进行添加
    Integer insertDelivery(LogisticsVo logisticsVo);
}
